Set up dimensions for current-year forecasting

Before taking advantage of the Current Year forecasting reports, you need to populate the following columns in the following dimensions:

• CYFMethod column in the ACCT table: Determines which forecasting method gets applied to each account. Refer to the Monthly Forecast Utility report for a list of account types and the methods most commonly used for each of them.

• CYFDimGrp column in the DEPT table: Determines which CYFMethod column each department uses to forecast accounts.

To set up dimensions for current-year forecasting:

1. Open the ACCT dimension table.

2. In the CYFMethod column, make the following changes:

   

   Row	Description
   Current Year Budget	RemBud = Remaining Budget from CYB
   Straight Line	Annual = YTD / Calendar Days * Remaining Calendar Days
   Historical Weighting Trend	Rolling12 = YTD Actual / YTD Budget * Remainder of LYA
   Budget Weighted Trend	PctBud = YTD Actual / YTD Budget * Remainder of CYB
   Variable	Actual Rate per Unit * Forecast Volume
   Trend	Trend Method (standard spreadsheet formula)
   CapBud	Remaining Budget Not to exceed the annual budget

3. In the Main ribbon tab, click Save.
4. To apply different sets of methods for different departments, create an additional column and enter a method for each account. You will determine which column each department refers to in the CYFDimGrp column of the DEPT dimension table. For more information, see Creating a grouping column.
5. Open the DEPT dimension table.

6. In the CYFDimGrp column, make the following changes:

   Row	Description
   CYFMethod	Uses the method specified in ACCT.CYFMethod.
   NA	For Not Applicable.
   [Other Column Name]	Uses the method specified in the corresponding column on the ACCT dimension table.